package cn.itcast.bassm.mapper;

import java.sql.Timestamp;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import cn.itcast.bassm.pojo.PublicandNumber;
import cn.itcast.bassm.pojo.Timeend;
import cn.itcast.bassm.pojo.Unitdoor;
import cn.itcast.bassm.pojo.Uploadfile;
import cn.itcast.bassm.pojo.User;
import cn.itcast.bassm.pojo.UserInformation;
import cn.itcast.bassm.pojo.Visitors;
import cn.itcast.bassm.pojo.Wx_access_token;
import cn.itcast.bassm.pojo.pathuser;

public interface UserMapper {
	public User queryUserById(@Param("id")int id);
	
	public User queryUserByPowrd(@Param("yusername")String yusername,@Param("ypassword")String ypassword);
	
	public void addUserInformation(@Param("urlimglist")String urlimglist,@Param("imgurl")String imgurl,@Param("name")String name,@Param("sex")String sex,@Param("phong")String phong,@Param("sfzid")String sfzid,@Param("detailed")String detailed,@Param("state")int state);
	
	public Uploadfile addqueryUserById(@Param("yid")String yid);
	
	public void updateUserState(@Param("id")int id,@Param("yindex")String yindex,@Param("idnumber")String idnumber,@Param("updatetime")String updatetime);
	
	public long getProductsCount(@Param("yaddress")String Celladdress1);
	
	public List<Uploadfile> selectProductsByPage(@Param("startPos")int startPos,@Param("yaddress")String Celladdress1,@Param("pageSize")int pageSize);
		
	public void savexdurl(@Param("scenePath")String scenePath,@Param("Timestamptime")Timestamp Timestamptime);
	
	public void deleimg(@Param("yid")String yid);
	
	public Uploadfile selectFinPhoneorUserName(@Param("yphone")String phonename,@Param("yname")String nameonefin);
	
	public List<Uploadfile> selectnameonefinPage(@Param("startPos")int startPos,@Param("yname")String yname,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public List<Uploadfile> selectFinPhoneorUserNameu(@Param("startPos")int startPos,@Param("yphone")String yphone,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public List<Uploadfile> selectallFInPage(@Param("startPos")int startPos,@Param("yphone")String yphone,@Param("yname")String yname,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public long getProductsCount2(@Param("yname")String yname,@Param("yaddress")String yaddress);
	
	public long getProductsCount3(@Param("yphone")String yphone,@Param("yaddress")String yaddress);
	
	public long getProductsCount4(@Param("yphone")String yphone,@Param("yname")String yname,@Param("yaddress")String yaddress);
	
	public List<Unitdoor> selecUnitdoor(@Param("address")String address,@Param("number")String number);
	
	public List<Uploadfile> selecfinuserlou(@Param("yid")String yid);
	
	public void UpselectFinto(@Param("yname")String yname,@Param("ydetailed")String ydetailed,@Param("yid")int yid,@Param("updatetime")String updatetime,@Param("cardnumber")String cardnumber);
	
	public void UpselectFintotime(@Param("yindex")String yindex,@Param("idnumber")String idnumber);
	
	public void savekahaouser(@Param("yname")String yname,@Param("ysex")String ysex,@Param("cardnumber")String cardnumber,@Param("yaddress")String yaddress,@Param("ydetailed")String ydetailed,
								@Param("yindex")String yindex,@Param("idnumber")String idnumber,@Param("updatetime")String updatetime,@Param("examine")String examine);
	
	public Uploadfile secletusergunone (@Param("yid")String yid);
	
	public Timeend secleTimeEnd (@Param("id")String id);
	
	public void uptimeend(@Param("timesetend")String timesetend ,@Param("id")String id);
	
	public void upexamine(@Param("examine")String examine ,@Param("yindex")String yindex ,@Param("yid")String yid,@Param("updatetime")String updatetime,@Param("idnumber")String idnumber);

	public void upexaminetwo(@Param("examine")String examine ,@Param("yid")String yid,@Param("updatetime")String updatetime,@Param("idnumber")String idnumber);

	public User seclectfinusermoeny(@Param("yaddress")String yaddress,@Param("ynumber")String ynumber);
	
	public void savetestoneuser(@Param("yfilename")String yfilename,@Param("yname")String yname,@Param("ysex")String ysex,
			@Param("yowner")String yowner,@Param("yphone")String yphone,@Param("yaddress")String yaddress,
			@Param("ydetailed")String ydetailed,@Param("createtime")String createtime,@Param("updatetime")String updatetime,@Param("yindex")String yindex,
			@Param("ynumber")String ynumber,@Param("idnumber")String idnumber,@Param("examine")String examine);
	
	public void updatevistorsendtime(@Param("yupdatetime")String yupdatetime,@Param("state")String state);
	
	public List<Uploadfile> chaxunuser();
	
	public List<Visitors> chaxunvisitors();
	
	public void deleteuserone(@Param("yid")String yid,@Param("updatetime")String updatetime,@Param("idnumber")String idnumber);
	
	public long getProductsCountwubohui();
	
	public List<pathuser> selectProductsByPagewubohui(@Param("startPos")int startPos,@Param("pageSize")int pageSize);
	
	public void insertpathtuisong(@Param("pathtuisong")String pathtuisong);
	
	public void insetInterfacestate(@Param("name")String name,@Param("state")String state,@Param("timeend")String timeend);
	
	public void insetPublicandNumber(@Param("openid")String openid,@Param("cardnumber")String cardnumber);
	
	public List<Uploadfile> selectFinuserandCardnumber(@Param("cardnumber")String cardnumber,@Param("yaddress")String yaddress);
	
	public List<PublicandNumber>selectFinuserandCardnumberandPublicandNumber(@Param("cardnumber")String cardnumber,@Param("yaddress")String yaddress,@Param("binding")String binding);
	
	public List<Uploadfile> selectFinuserandCardnumbertwo(@Param("cardnumber")String cardnumber,@Param("yaddress")String yaddress);
	
	public List<Uploadfile> selectFinuserandCardnumbertwoGo(@Param("cardnumber")String cardnumber);
	
	public  PublicandNumber selectFinuserandPublicandNumber(@Param("openidto")String openidto);
	
	public List<Unitdoor> YaddressandSelectUnitdoor(@Param("yaddress")String yaddress);
	
	public void UpweixinandUser(@Param("yid")String yid ,@Param("address")String address,@Param("dong")String dong,@Param("nickname")String nickname ,@Param("moblie")String moblie,@Param("yowner")String yowner,@Param("ysex")String ysex,
			@Param("updatetime")String updatetime ,@Param("yindex")String yindex ,@Param("examine")String examine ,@Param("idnumber")String idnumber );
	
	public List<PublicandNumber> selectandPublicandNumber(@Param("openid")String openid);
	
	public void UpandPublicandNumberopenid(@Param("openid")String openid,@Param("cardnumber")String cardnumber,@Param("yaddressto")String yaddressto,@Param("bindingto")String bindingto,@Param("yid")String yid);
	
	public PublicandNumber  selectFinuserandCardnumberandPublicandNumber(@Param("openid")String openid);
	
	public Uploadfile  selectFinuserandCardnumberandNull(@Param("cardnumber")String cardnumber);
	
	public PublicandNumber  selectFinuserandPublicandNumberandCardnumber(@Param("openid")String openid);
	
	public void  UpCardnumberanduser(@Param("yindex")String yindex,@Param("examine")String examine,@Param("updatetime")String updatetime,@Param("weixinfollow")String weixinfollow,@Param("cardnumber")String cardnumber,@Param("yaddress")String yaddress,@Param("yid")String yid);
	
	public void deleteandusertoidnumber(@Param("idnumber")String idnumber);
	
	public PublicandNumber selectPublicandNumberandcardnumber(@Param("openid")String openid);
	
	public PublicandNumber selectandPublicandcardnumberno(@Param("openid")String openid);
	
	public void UpPublicandNumberandbangding(@Param("openid")String openid,@Param("yaddress")String yaddress,@Param("binding")String binding,@Param("yid")String yid);

	public Wx_access_token selectandwx_access_token(@Param("id")String id);
	
	public void upandwx_access_token(@Param("createtime")Long createtime,@Param("createdate")String createdate,@Param("accesstoken")String access_token,@Param("expiresin")String expiresin2,@Param("id")String id);
	
	public void intsetandwx_access_token(@Param("createtime")Long createtime,@Param("userid")String userid,@Param("createdate")String createdate,@Param("accesstoken")String access_token,@Param("expiresin")String expiresin);

	
}
